package com.xhapi.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.xhapi.pojo.dto.ScoreAvgBySubject;
import com.xhapi.pojo.entity.Score;


import java.util.List;

public interface ScoreService {
    int add(Score score);

    List<Score> findAll();

    IPage<Score> findById(Page page, Integer studentId);

    List<Score> findById(Integer studentId);

    List<Score> findByExamCode(Integer examCode);

    /*
    * 查询所有科目的平均分
    * */
    List<ScoreAvgBySubject> selectAvg(String subject);
}
